﻿if exists (select * from dbo.sysobjects where name = 'sp_Contract_Update')	drop procedure [dbo].[sp_Contract_Update]Go CREATE PROCEDURE dbo.sp_Contract_Update	@ConID		int,	@uID		int,	@Number		int,	@Type		int,	@StartDate		datetime,	@EndDate		datetime,	@Date		datetime,	@Detail		ntext,	@Status		nvarchar(50)AS	UPDATE [Contract] SET [uID] = @uID, [Number] = @Number, [Type] = @Type, [StartDate] = @StartDate, [EndDate] = @EndDate, [Date] = @Date, [Detail] = @Detail, [Status] = @Status	 WHERE ConID = @ConIDGo 